JDBC Data Source

Please enter the following parameters to connect to a JDBC data source:

• Alias: name of the data source to be used in CData Virtuality Server
• Host / Port: IP address or hostname and port of the server where the data source is running
• SSL: use encrypted connection (available for Redshift data source)
• Schema / Database / SID / File / Catalog etc.: schema / database name / SID / file path / absolute path of the Advantage Data Dictionary (.add file) / the path to the directory containing free tables (depends on the data source type) of the data source to connect to
• User name / Password: credentials to connect to data source
• Data source parameters: additional connection parameters
• Translator parameters: additional translator parameters
• JDBC parameters: additional JDBC parameters

Below are some examples of the most common data source parameters, see the reference manual for the full list:

• importer.useFullSchemaName=TRUE - schema names will be prefixed to table names to avoid duplicates
• importer.importProcedures=TRUE - stored procedures will be imported
• importer.useProcedureSpecificName=TRUE - when two stored procedures being imported have identical names, an index will be appended to their names in order to avoid conflicts

To test the connection parameters press the Test connection button.

RDBMS Table Types

This section shows all the possible table types that can be retrieved for a particular RDBMS server with the importer.tableTypes property.

• ALIAS
• HIERARCHY TABLE
• INOPERATIVE VIEW
• MATERIALIZED QUERY TABLE
• NICKNAME
• SYSTEM TABLE
• TABLE
• TYPED TABLE
• TYPED VIEW
• VIEW

• SYSTEM TABLE
• TABLE
• TABLE LINK
• VIEW

• SYSTEM TABLE
• TABLE
• VIEW
• MS SQL jTDS
• SYSTEM TABLE
• TABLE
• VIEW

• LOCAL TEMPORARY
• TABLE
• VIEW
• Oracle
• SYNONYM
• TABLE
• VIEW

• FOREIGN TABLE
• SYSTEM TABLE
• SYSTEM TOAST INDEX
• SYSTEM TOAST TABLE
• SYSTEM VIEW
• TABLE
• TEMPORARY INDEX
• TEMPORARY SEQUENCE
• TEMPORARY TABLE
• TEMPORARY VIEW
• TYPE
• VIEW